Solve the problem of breaking PivotTable data sources when rows are added by using dynamic named ranges to automatically expand the source range.